<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>The Vtiful\Kernel\Excel class</title>
<link media="all" rel="stylesheet" type="text/css" href="styles/03e73060321a0a848018724a6c83de7f-theme-base.css" />
<link media="all" rel="stylesheet" type="text/css" href="styles/03e73060321a0a848018724a6c83de7f-theme-medium.css" />

 </head>
 <body class="docs"><div class="navbar navbar-fixed-top">
  <div class="navbar-inner clearfix">
    <ul class="nav" style="width: 100%">
      <li style="float: left;"><a href="xlswriter.constants.html">« 预定义常量</a></li>
      <li style="float: right;"><a href="vtiful-kernel-excel.addSheet.html">Vtiful\Kernel\Excel::addSheet »</a></li>
    </ul>
  </div>
</div>
<div id="breadcrumbs" class="clearfix">
  <ul class="breadcrumbs-container">
    <li><a href="index.html">PHP Manual</a></li>
    <li><a href="book.xlswriter.html">XLSWriter</a></li>
    <li>The Vtiful\Kernel\Excel class</li>
  </ul>
</div>
<div id="layout">
  <div id="layout-content"><div id="class.vtiful-kernel-excel" class="reference">

 <h1 class="title">The Vtiful\Kernel\Excel class</h1>
 

 <div class="partintro"><p class="verinfo">(PECL xlswriter &gt;= 1.2.1)</p>


  <div class="section" id="vtiful-kernel-excel.intro">
   <h2 class="title">简介</h2>
   <p class="para">
    Create xlsx files and set cells and output xlsx files
   </p>
  </div>


  <div class="section" id="vtiful-kernel-excel.synopsis">
   <h2 class="title">类摘要</h2>


   <div class="classsynopsis">
    <div class="ooclass"></div>


    <div class="classsynopsisinfo">
     <span class="ooclass">
      <span class="modifier">class</span> <strong class="classname">Vtiful\Kernel\Excel</strong>
     </span>
     {</div>


    <div class="classsynopsisinfo classsynopsisinfo_comment">/* 方法 */</div>
    <div class="constructorsynopsis dc-description">
   <span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.construct.html" class="methodname">__construct</a></span>(<span class="methodparam"><span class="type">array</span> <code class="parameter">$config</code></span>)</div>

    <div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.addSheet.html" class="methodname">addSheet</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$sheetName</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.autoFilter.html" class="methodname">autoFilter</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$scope</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.constMemory.html" class="methodname">constMemory</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$fileName</code></span>, <span class="methodparam"><span class="type">string</span> <code class="parameter">$sheetName</code><span class="initializer"> = ?</span></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.data.html" class="methodname">data</a></span>(<span class="methodparam"><span class="type">array</span> <code class="parameter">$data</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.filename.html" class="methodname">fileName</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$fileName</code></span>, <span class="methodparam"><span class="type">string</span> <code class="parameter">$sheetName</code><span class="initializer"> = ?</span></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.getHandle.html" class="methodname">getHandle</a></span>()</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.header.html" class="methodname">header</a></span>(<span class="methodparam"><span class="type">array</span> <code class="parameter">$headerData</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.insertFormula.html" class="methodname">insertFormula</a></span>(<span class="methodparam"><span class="type">int</span> <code class="parameter">$row</code></span>, <span class="methodparam"><span class="type">int</span> <code class="parameter">$column</code></span>, <span class="methodparam"><span class="type">string</span> <code class="parameter">$formula</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.insertImage.html" class="methodname">insertImage</a></span>(<span class="methodparam"><span class="type">int</span> <code class="parameter">$row</code></span>, <span class="methodparam"><span class="type">int</span> <code class="parameter">$column</code></span>, <span class="methodparam"><span class="type">string</span> <code class="parameter">$localImagePath</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.insertText.html" class="methodname">insertText</a></span>(<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">int</span> <code class="parameter">$row</code></span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">int</span> <code class="parameter">$column</code></span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type"><span class="type">int</span>|<span class="type">float</span>|<span class="type">string</span></span> <code class="parameter">$data</code></span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class="methodparam"><span class="type">string</span> <code class="parameter">$format</code><span class="initializer"> = ?</span></span><br>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.mergeCells.html" class="methodname">mergeCells</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$scope</code></span>, <span class="methodparam"><span class="type">string</span> <code class="parameter">$data</code></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.output.html" class="methodname">output</a></span>()</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.setColumn.html" class="methodname">setColumn</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$range</code></span>, <span class="methodparam"><span class="type">float</span> <code class="parameter">$width</code></span>, <span class="methodparam"><span class="type">resource</span> <code class="parameter">$format</code><span class="initializer"> = ?</span></span>)</div>
<div class="methodsynopsis dc-description"><span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.setRow.html" class="methodname">setRow</a></span>(<span class="methodparam"><span class="type">string</span> <code class="parameter">$range</code></span>, <span class="methodparam"><span class="type">float</span> <code class="parameter">$height</code></span>, <span class="methodparam"><span class="type">resource</span> <code class="parameter">$format</code><span class="initializer"> = ?</span></span>)</div>

   }</div>


  </div>

 </div>

 










































































































<h2>目录</h2><ul class="chunklist chunklist_reference"><li><a href="vtiful-kernel-excel.addSheet.html">Vtiful\Kernel\Excel::addSheet</a> — Vtiful\Kernel\Excel addSheet</li><li><a href="vtiful-kernel-excel.autoFilter.html">Vtiful\Kernel\Excel::autoFilter</a> — Vtiful\Kernel\Excel autoFilter</li><li><a href="vtiful-kernel-excel.constMemory.html">Vtiful\Kernel\Excel::constMemory</a> — Vtiful\Kernel\Excel constMemory</li><li><a href="vtiful-kernel-excel.construct.html">Vtiful\Kernel\Excel::__construct</a> — Vtiful\Kernel\Excel constructor</li><li><a href="vtiful-kernel-excel.data.html">Vtiful\Kernel\Excel::data</a> — Vtiful\Kernel\Excel data</li><li><a href="vtiful-kernel-excel.filename.html">Vtiful\Kernel\Excel::fileName</a> — Vtiful\Kernel\Excel fileName</li><li><a href="vtiful-kernel-excel.getHandle.html">Vtiful\Kernel\Excel::getHandle</a> — Vtiful\Kernel\Excel getHandle</li><li><a href="vtiful-kernel-excel.header.html">Vtiful\Kernel\Excel::header</a> — Vtiful\Kernel\Excel header</li><li><a href="vtiful-kernel-excel.insertFormula.html">Vtiful\Kernel\Excel::insertFormula</a> — Vtiful\Kernel\Excel insertFormula</li><li><a href="vtiful-kernel-excel.insertImage.html">Vtiful\Kernel\Excel::insertImage</a> — Vtiful\Kernel\Excel insertImage</li><li><a href="vtiful-kernel-excel.insertText.html">Vtiful\Kernel\Excel::insertText</a> — Vtiful\Kernel\Excel insertText</li><li><a href="vtiful-kernel-excel.mergeCells.html">Vtiful\Kernel\Excel::mergeCells</a> — Vtiful\Kernel\Excel mergeCells</li><li><a href="vtiful-kernel-excel.output.html">Vtiful\Kernel\Excel::output</a> — Vtiful\Kernel\Excel output</li><li><a href="vtiful-kernel-excel.setColumn.html">Vtiful\Kernel\Excel::setColumn</a> — Vtiful\Kernel\Excel setColumn</li><li><a href="vtiful-kernel-excel.setRow.html">Vtiful\Kernel\Excel::setRow</a> — Vtiful\Kernel\Excel setRow</li></ul>
</div>
</div></div></body></html>